| StudentGroupMember |
| EntityType | Independent |
| Logical Entity Name | StudentGroupMember |
| Default Table Name | SyStudGrp |
| Logical Only | NO |
| Definition | |
| Note |
| StudentGroupMember Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| StudentId | INTEGER | NO | ||
| StudentGroupId | INTEGER | NO | ||
| CampusId | INTEGER | NO | ||
| IsActive | BIT | NO | ||
| AddedByUserId | INTEGER | NO | ||
| EffectiveDate | DATETIME | YES | ||
| RemovedByUserId | INTEGER | NO | ||
| RemovedDate | DATETIME | YES | ||
| ModFlag | CHAR(1) | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
Id |
INTEGER | NO | ||
| AwardYear | CHAR(7) | YES | ||
| IsManualUpdated | BIT | NO |
| StudentGroupMember Keys |
| Key Name | Key Type | Keys |
| SyStudGrp_SyCampusID_N_N_IDX | Inversion Entry | CampusId |
| SyStudGrp_SySGroupsID_Active_DateOff_SyStudentID_AwardYear_N_N_IDX | Inversion Entry | StudentGroupId, IsActive, RemovedDate, StudentId, AwardYear |
| SyStudGrp_SyGroupsID_SyCampusID_N_N_IDX | Inversion Entry | StudentGroupId, CampusId |
| Nk_SyStudGrp_SyStudentID_SyGroupsID_INCL_3_4 | Inversion Entry | StudentId, StudentGroupId |
| SyStudGrp_SyStudGrpID_U_C_IDX | PrimaryKey | Id |
| SyStudGrp_SyGroupsID_Active_SyStudentID_N_N_IDX | Inversion Entry | StudentGroupId, IsActive, StudentId |
| StudentGroupMember Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| StudentGroupMember Check Constraints |
| Check Constraint Name | CheckConstraint |